SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43879 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43879 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042206,620671,441497,841998,450183,754229,478690,459642,42529,565294,747677,419129,970146,899273,636971,466489,279686,942472,192805,44841,1044816,500144,896388,1001742,922823,986285,328864,371238,674306,271131,614726,224294,566161,1048148,973127,440810,421847,709936,147945,121389,96953,546975,911738,927167,752110,937314,627645,890844,429052,695790,978988,67138,1031796,682613,872109,53185,438739,413781,454206,514436) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43879 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43879 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002099s ]