SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027053 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027053 [ RunTime:0.001675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (208653,457392,524943,395054,1047599,854980,485548,824575,152589,1008982,633569,187092,869471,389095,428783,957734,816107,1010096,157469,527635,1017639,829843,456183,872833,735175,547322,985346,738915,181302,824394,815724,650828,599587,982587,100251,67929,115615,1016672,96311,578818,676305,664079,261029,379118,781280,230920,881628,48006,151317,114456,1000962,616435,294861,415339,927764,229889,175239,945850,967792,669442) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]