SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439876 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439876 [ RunTime:0.001983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (206151,889757,582466,780055,521327,468608,392789,705849,452484,753109,650354,718505,418179,362348,97340,341024,36303,104926,179635,398118,981851,1013170,76421,531059,995747,994362,166366,359907,334075,663536,1029200,812146,118235,432904,596869,779761,511825,177504,342060,1013695,135462,598618,524833,1036513,465196,502097,647998,49591,62079,635698,1013437,576568,1019543,17644,404132,926591,778346,1033996,486062,223943) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]