SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428800 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428800 [ RunTime:0.002421s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383419,495729,242267,492980,383077,475522,873014,38022,202216,751373,294772,161052,302037,984530,669918,830617,525553,433966,908051,461086,578473,443706,471937,312351,906652,828464,766675,736950,405327,264189,1010600,797219,927102,853884,98658,1043424,313607,700567,39448,89608,326280,702974,446026,220559,398892,637783,116447,586179,929010,676487,700722,1028344,595647,959779,169128,73440,266649,844876,378461,884164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]