SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485936 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485936 [ RunTime:0.002755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001546,988790,366230,243767,430237,702818,602059,34063,827853,395101,504709,689870,336230,750372,319912,886275,403056,1002378,843045,282384,86494,15465,855436,151963,66473,7588,355523,560603,255818,420002,445486,515734,103356,958819,235547,792718,836598,485116,183047,50147,628405,814851,345345,629730,179207,879788,1004371,1000474,254944,581047,781969,624896,494259,521826,936242,695513,312210,707008,917542,608186) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000763s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]