SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476680 LIMIT 1 [ RunTime:0.000541s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476680 [ RunTime:0.002259s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447703,397161,621983,713896,585078,977147,1000250,88663,542508,864555,1037357,289633,497420,151432,84769,587432,715597,455235,987075,280901,555465,358764,977997,290694,45191,734006,898418,605931,508440,935388,399860,335416,431491,120937,497683,661716,286604,384762,508018,179127,620096,952531,776643,314150,983938,316600,484322,895680,267141,955142,275129,289882,92635,578746,1028066,1036671,428948,648949,623017,276147) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]