SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002678s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501528 LIMIT 1 [ RunTime:0.003416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501528 [ RunTime:0.005037s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486716,315099,425521,259231,9724,264582,882288,150620,25141,473758,461648,714372,320379,527753,288671,710918,304813,754653,713372,975272,516770,600414,367667,868391,13139,988411,240393,820272,809209,42683,219974,234197,824102,232732,88395,396456,249787,702880,241470,731499,979062,380065,1043378,333726,656564,569588,680319,259115,291598,344269,128844,416778,654160,220272,193393,721807,592475,574874,495534,163125) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000685s ]