SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001660s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 922808 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 922808 [ RunTime:0.003123s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012692,977908,442213,170512,954193,366201,597373,409090,511515,685131,1041320,590855,1015141,406944,6488,561473,917380,39592,426800,943452,225625,342340,248976,903998,914751,710846,644698,241006,251567,944275,944200,204554,959424,672569,1047489,868252,177515,508096,435646,681499,1025330,607663,99897,323883,989833,5798,56909,1003885,300406,369145,258876,153680,600188,447695,751969,313644,687089,848681,861901,309374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 922808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 922808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]