SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421804 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421804 [ RunTime:0.001834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (25250,202304,812145,903813,86841,601644,792919,1019337,957057,991603,788832,1031267,600903,237133,1019456,748258,397537,664917,522079,938681,495895,649427,655087,640097,407364,738722,533334,16313,875327,577080,747825,683766,610663,1030921,525627,445683,445282,858214,890606,666689,710983,468001,646222,37284,740880,187141,400915,296938,864028,404388,350112,633534,667267,533184,779078,953220,383291,945759,467975,534149) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]