SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004539 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004539 [ RunTime:0.002544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045826,1029742,532884,632317,57222,481737,535766,659545,370407,773264,435048,208891,473372,450924,251470,246753,355478,165540,255021,741329,596419,825477,131091,900396,691361,762089,295746,856570,993567,195048,424182,122940,565039,167014,474679,618872,275824,1015627,786220,299968,960125,851267,390756,755898,704065,791096,832985,1030284,501404,462731,503703,18408,730621,169554,940084,1038645,314513,317721,506585,713667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001781s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004539 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004539 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]