SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505627 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505627 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219346,42256,930387,776100,238316,538956,939881,865589,752841,297082,716292,325647,576170,163240,795354,184207,699764,980170,786880,566902,309558,781161,784143,12534,684834,783861,470500,826395,456805,175696,350480,426732,292378,692976,568820,535975,192599,871939,393402,81017,543664,398089,444963,987582,45800,222488,776796,369002,16148,349490,663834,18060,420484,247931,517382,650108,464992,957615,821091,346487) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505627 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505627 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]