SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284196 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284196 [ RunTime:0.002607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690093,494404,511791,198278,208947,874806,927216,556943,277783,598872,73401,108023,698084,971610,589606,862902,832058,513979,769244,878601,455835,315123,622163,850203,193980,784535,871782,553718,117959,271706,314487,930684,858895,439574,551613,661782,48344,749120,525563,357854,20803,165238,1012354,549294,849446,10450,109820,851832,846201,1030497,188879,705357,694426,277990,201710,176831,890343,756497,765138,421873) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]