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` = 1017516 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017516 [ RunTime:0.002324s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140120,863365,974784,658706,350126,963390,877639,475756,452606,135426,367355,1019974,74061,760805,715302,991596,911689,69398,489787,715507,828929,772497,691623,92040,937972,420876,321523,89352,355865,502613,403887,372268,949682,293320,261960,945857,747498,119409,72151,893594,361135,794474,658454,606379,589760,73040,192152,1015873,71181,187353,567928,1013902,409828,301337,960212,117086,556455,278890,818410,849789) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]