SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541140 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541140 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (43058,87118,243896,894381,1003383,157637,204359,726633,466705,1042519,166965,409876,168873,945823,408115,93749,356889,918323,314737,285822,961907,810385,639786,401386,627400,886089,909696,684152,767011,462013,763469,622877,836507,892402,787816,312763,575650,489103,596963,808505,1029110,245995,1022379,41739,521008,106923,385527,905122,540563,705156,320879,484909,873557,1021164,149725,980732,963994,972676,905983,24064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000679s ]