SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001704s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486251 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486251 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (844462,487891,357773,968694,109150,275519,1044168,87715,711094,957471,622201,899770,132395,720815,896887,208443,971653,323504,858584,292824,490372,351403,1034284,796995,757437,982546,364370,305891,563287,546881,887865,963925,79120,186740,772828,399412,928448,800925,245325,41516,119138,744997,128398,9182,1042180,125388,481374,854715,616650,839478,639278,160018,290269,755956,345225,551390,699204,421870,979905,1028602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]