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` = 50396 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50396 [ RunTime:0.001501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (178933,387630,450620,205203,803058,917081,817704,813661,231999,840025,1015924,346270,820512,740608,915251,723523,588620,827187,424357,259367,558010,31714,147813,898033,276271,916007,815883,850537,291189,705670,1004889,403838,487510,66962,736091,93115,691701,422538,159374,190973,235594,425584,799629,226575,294191,35861,136512,518217,852123,26450,927079,924976,567581,844508,120546,284326,766646,937308,396054,451873) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]