SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003806s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392320 LIMIT 1 [ RunTime:0.003635s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392320 [ RunTime:0.005625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (360979,1032303,986383,599799,123255,169839,397472,32372,1000875,550264,296060,719003,240816,851664,896124,887260,560819,326978,658276,720994,394259,478050,435163,468762,878011,679710,629967,317461,688362,942995,177246,156833,225834,397670,688405,1005255,682078,1033277,792993,880638,709950,27866,85148,342803,278830,173544,1003001,139339,571292,780578,200267,792382,1040765,470274,377726,894283,302715,674298,245674,167993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]