SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 604018 LIMIT 1 [ RunTime:0.000785s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 604018 [ RunTime:0.002177s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938322,637154,488174,146789,52352,938559,76885,191884,128856,60299,172066,112384,397126,1009264,70425,728183,778408,874409,39227,515176,514336,977627,365636,761340,179267,505228,497628,803353,1042963,788298,391110,323437,882064,701159,314666,563304,504236,553032,210227,95122,263687,1008302,702005,677667,765288,29027,782705,961399,231732,814016,553525,818167,616584,199610,950659,333765,403167,311954,550610,769030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 604018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002892s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 604018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]