SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104820 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104820 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001987,102382,899932,721386,253722,358902,191337,406336,273999,412623,706035,247020,619855,821983,824733,776160,482937,921964,441469,130410,171326,9386,417116,847365,969893,633649,973160,177705,861248,644640,958986,823393,671781,691521,929708,617537,769378,309345,490723,18228,1007494,861343,301796,741487,367197,145541,19542,915984,635894,867765,897864,577077,441844,947625,603616,686816,405484,878277,1015585,535128) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]