SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 960413 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 960413 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473568,698690,84832,334119,645632,758773,933287,948026,857990,533937,852674,406459,627931,259762,294828,753119,169861,685613,705029,9657,961197,790866,723632,243630,387634,209231,168980,259118,427075,775946,276140,355900,10420,921604,1043391,79092,831979,608813,525343,148996,996281,254462,151435,759521,266933,156873,1031965,301982,104027,251363,782098,175169,112335,811380,1009422,448010,820996,277422,472771,326672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 960413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 960413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000401s ]