SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500428 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500428 [ RunTime:0.002722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (917002,232474,379559,991764,138323,567184,438984,164264,417057,657414,591958,82781,400452,344298,55451,127766,269418,571016,374456,449573,710009,323717,265357,995548,941459,477883,420606,392166,18421,270803,357571,769011,72862,319641,536434,576918,97830,340394,933198,752072,313036,865797,1035477,475481,650333,734985,324371,907263,645388,399513,608969,917722,603884,309583,425605,881207,987741,1018437,540595,22298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000748s ]