SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001662s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048057 LIMIT 1 [ RunTime:0.001487s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048057 [ RunTime:0.003380s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506682,472866,417817,624723,1022381,413736,51920,795069,547911,654365,87759,824180,807843,783919,761784,683375,655047,103693,335079,714304,135278,545621,606427,1013431,50029,613045,503248,48113,744565,177431,822364,195455,1036243,4984,717022,839120,26806,637563,857286,1019274,1035722,313696,894108,247911,362167,930162,277545,573581,235049,987681,919070,1040841,157830,290594,333792,50223,837473,630084,762882,844237) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048057 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048057 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]