SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002477s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451582 LIMIT 1 [ RunTime:0.001335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451582 [ RunTime:0.005160s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674076,1041964,1013704,334820,863599,666210,37154,864810,452900,687978,235775,498495,253619,925727,215787,580082,491147,1030652,184377,328297,249621,641195,415768,475237,866674,786101,869121,790301,534289,907242,294589,683638,804769,212642,571285,923217,993014,30424,946246,16305,232372,390973,107324,366820,746061,148859,133,306014,335214,887220,386896,337681,151653,1031192,535073,1015982,986827,622170,531795,745748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]