SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534881 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534881 [ RunTime:0.002208s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046792,838508,259790,917027,18130,923520,279553,627461,250921,266140,855966,587493,954356,473544,179721,391350,872894,512869,119387,526998,628725,507660,362438,332722,480813,1021181,444854,153610,320153,390688,526914,881158,412757,844485,298185,623445,395800,429534,159753,848726,778457,19473,161354,851821,168787,275514,924495,950392,304431,610487,71649,559607,684370,956698,454449,213812,545600,626366,500412,1011693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]