SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504812 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504812 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614872,356471,610565,106494,467822,415226,605027,788731,471650,608856,164575,642632,378118,452529,659723,320783,743612,310812,389268,819797,218407,440311,888062,683863,713778,341068,786499,623337,1025809,994977,1028681,762407,158491,678240,543266,142246,902796,998490,897491,996592,47426,713456,1002540,1034701,536658,512476,827819,845413,103001,74684,816909,14145,316971,195140,841148,461521,501262,258694,480244,309318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]