SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 991018 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 991018 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (669862,122713,997132,743064,708109,101632,881003,678141,76849,868123,794169,577482,1008529,265086,180048,873022,614608,744497,357409,186729,331063,307421,303021,292346,217086,348203,955231,1033544,436761,52715,211624,889335,800122,827550,227971,482028,306943,562225,70799,952141,350566,1002982,841958,896899,830310,897029,59585,176149,840654,351318,884799,427535,931710,704232,830190,150022,207219,159627,533867,166596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 991018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 991018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000733s ]