SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017157 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017157 [ RunTime:0.001395s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (807796,259216,157263,845238,491292,668482,401888,822102,1035135,511103,550155,17387,135017,503547,245869,770871,672077,925702,546192,825266,834617,944768,793748,155784,244821,159383,73617,648060,702218,504271,1020961,216726,416865,126644,253735,415103,717624,981845,478619,37246,621624,87188,16918,801106,1022050,80836,819175,319489,850589,797919,762614,99943,1004299,635480,420146,347986,1004268,712442,429222,515127) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000907s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017157 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017157 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001239s ]