SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293928 LIMIT 1 [ RunTime:0.000500s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293928 [ RunTime:0.002503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (743560,30976,643849,160577,35295,865553,8717,54720,799998,366335,119258,259090,662402,673559,317832,29300,489549,712905,60985,67132,1034450,454181,668387,665104,565480,682869,955564,747363,226335,810277,607898,131653,399191,580213,562145,543435,739514,345459,394345,147290,144438,570212,356296,960436,27809,957807,1023064,154248,988910,707050,174001,929238,352677,135478,8096,481468,132645,675026,257648,507246) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]