SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 143906 LIMIT 1 [ RunTime:0.000564s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 143906 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011078,486782,779245,344620,436136,877531,605348,971476,504032,595908,643309,371947,192597,218182,267880,502732,524841,46770,520631,635660,532816,219761,606173,72738,94364,585770,688829,123641,762811,892814,106524,705765,362632,289655,225104,845961,534507,232340,295904,1042376,179725,689413,1009526,917165,198599,955961,788196,803270,254370,470058,820159,546137,970311,331042,351289,370527,310195,98323,1026469,112236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 143906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 143906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000735s ]