SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003771s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391500 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391500 [ RunTime:0.005082s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583826,84611,704468,685004,106964,922840,654712,461155,750103,406071,258747,98554,947570,1008297,592076,468514,567024,217225,633797,247405,436017,1011070,257029,105488,814776,730306,447720,526016,436913,1044277,490335,1003408,44528,132393,777220,774384,303286,437501,954989,61015,643789,548679,166521,72099,223285,406355,742705,361729,960667,811087,808822,754508,68636,121384,827604,1016056,329997,49483,776515,313188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]