SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540396 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540396 [ RunTime:0.002596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672359,642204,945896,30514,90653,440483,967098,331202,351668,988321,200597,376323,401489,201369,826564,331447,506804,837650,867806,48826,1014612,167974,912831,271070,312018,406653,119720,72153,745059,314299,958222,1036535,165242,684901,957808,4030,982937,221022,830295,387186,650592,731082,393407,1014056,945514,492561,788334,674540,390412,301663,93419,646955,307934,703378,1033313,444493,331600,412297,717939,144101) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]