SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502105 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502105 [ RunTime:0.004064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (687621,625979,117890,210519,264410,953914,394197,764458,70426,565468,195275,970420,782295,935717,1028366,573924,114075,455382,468180,543485,709208,110771,120973,896441,350815,641438,246556,823873,278903,12355,963834,399312,451464,769679,221855,975625,664745,1027828,43932,734814,627262,871346,250617,901647,60813,505426,357329,481231,808853,301670,556584,320949,844539,1045215,1006906,911363,946720,563079,885629,1006509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001761s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]