SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287613 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287613 [ RunTime:0.002372s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185497,250816,486795,178013,193539,933979,250380,375835,46695,186880,4180,259665,641010,127909,762175,142151,989996,974024,168711,431175,618218,121135,880738,815337,948619,993913,291499,793867,432954,561331,432179,221594,85868,209565,720683,742619,237323,73432,606469,953897,889034,696817,678463,106076,73571,21516,779313,480809,77762,948599,498268,502609,797733,166555,48556,134549,224906,236706,932830,401935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]