SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 129201 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 129201 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521625,1044500,1044418,68872,469362,384742,840087,510761,35493,225650,369966,846895,683955,107167,540946,650022,187742,168986,1008531,599746,703606,706285,421943,543323,387592,106703,1009861,467369,316526,749094,649726,749971,116222,904248,419352,658506,533932,409081,135738,315580,607040,217171,605949,549447,1005898,10319,181980,243340,323268,901239,834151,1039993,505569,55954,330821,195937,515933,226215,423260,972420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 129201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 129201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000813s ]