SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001613s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428021 LIMIT 1 [ RunTime:0.000485s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428021 [ RunTime:0.003634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000003,24772,928398,822282,415659,628710,618375,938079,614614,314608,384572,248369,37805,941435,252235,265789,540246,379334,808483,778883,871410,491528,617088,915630,530186,491564,661161,420724,439424,456194,201759,299711,990459,949415,957013,552424,500485,727579,833955,89134,29028,967502,339072,804085,400659,599393,809143,29857,333313,943864,487328,637574,613656,363691,455194,659571,715276,468058,62253,812994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]