SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001709s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544796 LIMIT 1 [ RunTime:0.000545s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544796 [ RunTime:0.002434s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (729942,741310,459000,7015,186668,131040,927246,821727,759815,172117,579511,279187,296867,949786,521257,76811,868019,284156,94434,775844,275962,60596,28180,465056,743246,255741,781270,55246,995648,209448,413669,702788,116129,781022,550656,789184,88321,284604,761313,1007075,297033,274012,813581,61307,962814,253706,254125,435442,1021145,990694,36684,896047,865205,126596,325482,387929,963503,468699,1017938,894344) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002752s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544796 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000725s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544796 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000860s ]