SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 621087 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 621087 [ RunTime:0.002345s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200931,338861,800415,967844,590865,641875,375519,1023784,747890,51437,546109,385627,898193,671288,39896,375104,647049,38101,181518,240886,336602,610593,11926,294371,1018889,967796,762022,607131,40433,645014,167476,290421,416339,1035664,753265,971432,703518,784746,931480,1006081,996205,1030400,662291,297710,740742,74794,354303,752589,462481,649656,136549,902842,253752,362209,597702,184761,635285,1045258,1034817,478287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 621087 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 621087 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]