SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028870 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028870 [ RunTime:0.001972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (815282,673024,415252,119705,192118,955284,774363,732489,769332,853660,875439,393461,250520,467806,200208,336741,64587,1037030,187475,305400,38414,61465,227391,741726,162663,308645,910001,890994,507985,592870,949767,581471,1026111,976505,990049,406535,985322,799504,297489,243645,106077,508571,470389,605571,187448,620439,843029,369858,97397,651141,727889,620922,969998,927858,562374,98879,787053,575460,472238,497559) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028870 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028870 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001278s ]