SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501880 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501880 [ RunTime:0.001908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282099,31392,823207,893235,697323,1002747,254543,88614,680126,100744,437966,795662,234362,657541,360507,855765,204613,296519,861258,759307,439530,754569,984297,298191,488738,194871,939220,908493,882901,126723,659378,456644,527057,146813,138158,438301,238182,943188,69676,110422,1025450,14991,323057,869447,855751,841842,582493,382034,96074,198324,936251,295967,102432,125082,153495,101056,603155,963311,529832,762615) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]