SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515471 LIMIT 1 [ RunTime:0.002295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515471 [ RunTime:0.006361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (241792,292896,342099,726779,605820,790254,223764,106019,429967,975022,204020,395458,703619,880478,146323,99616,224708,72142,317156,17468,684539,536212,392794,412754,116526,630551,923552,268044,85059,354834,31465,285113,641935,234117,595175,19065,168367,238591,834228,71584,166994,770079,351615,322061,302049,927334,318213,528092,925597,588564,871596,866872,674248,967379,756263,523535,684777,121024,235667,368249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000759s ]