SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455105 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455105 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (686375,386826,456162,416442,850765,966169,781534,955914,113902,15378,1022863,252541,636762,1023149,934671,117110,832154,636617,117468,43375,988252,844090,1040864,952830,390741,157188,868698,862529,713113,702114,126910,583722,193764,249089,170148,117965,594540,214163,364295,684565,503981,438834,701528,308206,908292,478708,637784,593067,248618,489420,846839,499034,112250,1007915,671021,1004235,461257,872629,846740,656411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]