SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002388s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460531 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460531 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529639,485116,903840,696435,1005902,474027,852545,251712,354074,851598,907154,407656,244529,635237,879858,93665,133323,924783,243531,361376,596046,393190,943653,123238,766404,35979,572051,296440,899783,73162,401844,403015,954555,766230,168889,996367,424372,785127,743867,643158,446400,895072,19202,420460,874790,583758,330360,518271,889669,850446,894753,296037,536957,315299,850083,273824,268945,566442,2141,206964) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000654s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]