SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001739s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508530 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508530 [ RunTime:0.001708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403287,652687,217380,840501,335574,532755,738627,831013,303363,197547,426571,748212,657771,845077,472043,350023,33929,249284,583583,94766,395676,865734,478272,313505,688820,553150,612585,49095,839726,113611,755007,971103,1044910,282546,570164,1024979,107134,221079,814663,683489,520513,14007,545506,108043,483712,672967,277600,114426,736825,977017,615980,328761,288858,540711,201884,58567,879176,586237,477006,558326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508530 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508530 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001266s ]