SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455461 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455461 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205339,10993,173003,27666,752227,453713,735809,426096,188924,250147,213962,917281,199165,278074,498691,73623,606437,351081,433005,395056,340920,50777,327761,22053,303190,1028853,439912,385553,116075,649321,819714,735958,884276,643022,128092,971167,75768,695200,272228,398164,186612,321949,216322,400360,585428,887786,895980,529499,335736,539315,524835,107182,701066,557314,986490,1022070,270208,126473,898936,710999) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455461 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455461 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]