SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 360318 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 360318 [ RunTime:0.002590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475348,752428,431397,14641,1029416,978985,460847,689436,736021,409622,295815,683616,789339,1032736,656549,241421,6187,309906,69700,560082,408841,173154,1019101,106655,266035,693519,704920,907125,155200,204082,368187,924316,557553,263841,694076,221754,89331,31277,938085,207458,982837,485265,901984,996255,1038383,236818,197392,665462,734924,346199,1026000,258625,141574,589691,319928,410866,158696,577667,166952,504030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005848s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 360318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 360318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]