SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029718 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029718 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430431,448483,698531,724978,506694,75883,806141,821719,619423,373473,449129,282157,471210,629946,420935,235320,347820,816163,468861,186488,319863,776189,401582,972725,403980,113375,55318,856888,85071,994989,101202,448094,147227,523839,383302,169451,998208,961850,984298,956895,256193,223420,645944,678269,542179,145111,72547,1028851,652303,911481,72183,1035789,897787,950046,46163,152179,187629,11917,14108,1043520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]