SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537846 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537846 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (460748,711062,450005,229889,541928,888900,483016,275718,256414,85384,23834,678063,268027,391523,255031,355861,249087,988699,368132,833469,598271,531979,595785,212589,556240,531562,568739,650031,450649,706653,659088,239660,501007,670869,970429,42888,9481,901776,694876,949481,871388,872257,694271,710757,603602,32796,407487,971764,694361,847248,730076,391510,159429,577260,203316,563855,518263,820085,404443,881143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537846 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537846 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]