SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 138028 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 138028 [ RunTime:0.002220s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405550,414940,354504,36615,844338,478738,569776,522270,98766,647350,488789,603951,552954,619720,846692,193404,842700,851007,840624,627138,989465,106036,236707,729697,922735,255695,475461,240002,241532,838514,349910,958053,913495,490453,519738,642956,638170,711190,824404,975966,555056,750743,837724,830178,373509,553915,365908,891227,1026782,653625,319312,20091,226533,463756,993453,459584,728106,119337,439812,99741) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 138028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003920s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 138028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]