SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598810 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598810 [ RunTime:0.004274s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (917717,417298,251693,337908,1010239,47085,193374,809407,176320,756586,516899,417122,81537,105940,654604,891144,705792,178206,992550,222815,347452,313090,206471,222509,887373,767599,50602,942109,331634,334109,342812,875426,551717,704613,1002537,656587,503017,581324,529410,288224,230306,278888,801981,606002,197093,632156,385570,791713,858208,638222,437623,792928,486910,859463,713281,937468,432232,397794,739802,847916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]