SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291940 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291940 [ RunTime:0.002908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701813,878445,587005,148402,71686,705560,100762,877659,420131,543881,319142,673082,522966,323097,81954,839637,247704,569243,321257,479721,205917,446442,416571,809353,518974,968981,306484,256654,732454,82920,873455,569842,772196,785194,951970,977442,23058,459783,810971,913282,637536,906225,856211,282732,995744,709632,120003,138972,915520,913120,699099,346816,144993,438928,378459,426018,300502,369454,341574,434627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000669s ]