SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281981 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281981 [ RunTime:0.001818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220091,184444,596547,612890,794274,729412,554891,780381,369198,417295,199214,457365,617648,872835,524012,781786,428737,670808,1018880,336971,825996,323912,798053,665261,600147,513658,921570,125797,339950,433921,255149,905839,898806,34420,967332,645304,949433,112302,392654,822973,708039,853095,782636,786297,86417,269087,409435,307388,1001317,614368,354611,331952,909545,9007,851628,1035831,946407,178541,443369,473605) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]