SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104698 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104698 [ RunTime:0.002814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313498,821852,981701,1016154,802120,610370,758360,983268,945005,429544,967256,183859,54954,193512,107871,720472,544602,805298,697122,177282,866037,439859,724425,397738,312844,886952,44722,810334,483375,354713,739299,313916,712946,892344,778689,127427,88571,384170,405719,513816,829209,971565,194230,350954,684227,582498,440669,667534,895977,359209,582654,721192,732192,1024479,443469,56452,136741,781818,614771,449816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]