SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195407 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195407 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286025,378717,1048862,203245,652046,950268,141808,194594,772031,604347,442820,353910,9807,876669,244606,263645,455453,645120,331431,646328,308304,981826,915878,982109,588031,43328,16070,908844,344729,345593,500496,787082,438716,28921,756150,263203,428882,91556,196593,734984,492849,445367,36461,735896,674482,301176,502279,396247,161619,1035919,748212,490695,620186,1041232,610904,9105,888630,499136,737159,253014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]