SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531526 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531526 [ RunTime:0.001753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (972842,773455,414802,782098,71257,946887,752894,541605,123117,291044,864496,746603,448635,891590,604223,465709,288700,902466,895384,699424,328646,613353,263607,288719,966535,149738,588604,922338,230257,874073,969434,396230,210218,1039308,256009,587990,681957,409765,271716,215803,736503,799568,855628,799721,524756,75430,343208,81189,899366,983389,852262,606076,54020,94280,662913,934291,164644,223740,763982,886890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005831s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531526 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531526 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]