SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 302871 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 302871 [ RunTime:0.002290s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193450,1020561,1006692,824997,905228,236624,915665,969384,798334,1011788,249418,694971,217338,105857,433737,385151,947800,861271,117050,489675,20092,689079,644572,478866,205059,650092,238353,516793,700811,106375,197866,396242,107685,967750,1035630,272326,464369,385441,222178,29762,600389,422269,741097,431510,440817,562771,576883,73052,311944,559152,807972,479814,270937,438043,240878,23886,1026107,26115,253664,583365) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002917s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 302871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 302871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000884s ]