SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022084 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022084 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (613318,771134,1025562,104070,1028797,99417,986358,909897,878481,229856,506453,743160,997713,1017300,941677,497640,146000,1042325,937296,596254,969276,496284,433312,325793,808455,633578,195338,507786,366473,766902,931078,383481,595417,382788,341585,7335,1045141,687911,351053,371146,1045509,29146,977086,18202,162357,154814,70086,184196,295135,298506,719759,42410,586439,28843,324976,187859,1022809,390232,874479,779134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001714s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]