SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567308 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567308 [ RunTime:0.004035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (666040,54170,157995,1033175,981910,317234,279300,970582,355420,803680,611863,539172,572214,346123,943612,139892,60132,449177,26291,378001,775842,511409,823932,16841,592992,424587,211095,720943,202488,546175,236143,1021568,341892,1007317,410609,382379,435795,19080,401279,11704,863740,128859,235219,429730,1008780,339689,310478,570290,495241,685381,43216,859404,150402,486384,38114,896781,652177,104379,15505,631604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]