SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415306 LIMIT 1 [ RunTime:0.000544s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415306 [ RunTime:0.001703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430423,743172,271993,832108,310411,632299,537898,983641,829879,1007803,482171,925880,786966,979875,776016,284104,225902,787388,396336,684502,156210,732926,307464,117504,1028899,49813,637897,773129,233980,351429,487378,696917,381850,125020,623216,382936,546975,910679,674341,990255,933549,549610,383370,887472,499694,946766,52210,134486,149722,694150,79407,181475,800612,22533,7600,128066,381207,70894,44196,94244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]