SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293028 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293028 [ RunTime:0.001508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (953649,354430,85240,1042367,491107,987976,145000,18972,377621,654891,147778,493478,704427,663362,533639,543954,697782,628905,614429,998187,708295,315019,1031406,879961,629102,836287,372840,854255,354665,720731,999340,254599,341870,571869,112344,1003848,159502,658400,563956,718010,18209,74311,851857,569015,192732,541347,384355,850142,132018,225676,343501,203019,1009769,454258,545913,683766,656398,301797,822638,414276) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]