SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474259 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474259 [ RunTime:0.001469s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283485,107017,696237,543276,718192,810650,233893,603313,872285,794842,567408,843260,264798,578024,894581,728998,666171,782679,821423,927654,551707,283341,362158,562760,689858,511962,164714,494654,846869,226233,632319,49737,955870,846667,813992,133089,1020054,588669,223126,674524,169503,903898,347553,875362,15028,719044,112137,991222,759266,481360,1028531,734194,312081,198782,354642,115210,976938,172253,732047,592247) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474259 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474259 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]