SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001576s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 650923 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 650923 [ RunTime:0.001936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60242,421351,621626,38506,266603,608864,181724,519615,83183,288280,472977,494517,289906,889621,411406,456923,670844,582900,572598,360502,462801,80141,48120,193320,997455,200273,966644,974956,337428,357749,903060,571169,75560,782887,368094,562364,283153,236615,495471,696659,475373,579851,1042947,612728,791996,631910,471212,380478,460695,1030340,625780,223985,378714,579266,401847,901758,647921,676127,986170,551081) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 650923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 650923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]