SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506163 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506163 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457281,87663,400141,576414,302712,1000443,57369,292816,51323,652908,725124,273961,1010882,222420,618534,851155,1014416,221739,477722,48918,694729,585036,934066,248105,375030,470999,783676,705161,706401,931374,242373,278141,298837,970767,1019203,19736,350988,767834,867183,483313,580360,305492,450151,555309,752738,292559,739439,218297,1046245,204617,214373,1043590,662706,937747,890207,493291,111814,85582,891659,493067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506163 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506163 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]